Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_CHARSET_NAME

Syntax

Description of the illustration nls_charset_name.gif

Purpose

`NLS_CHARSET_NAME` returns the name of the character set corresponding to ID number `number`. The character set name is returned as a `VARCHAR2` value in the database character set.

If `number` is not recognized as a valid character set ID, then this function returns null.

Examples

The following example returns the character set corresponding to character set ID number 2:

    SELECT NLS_CHARSET_NAME(2)
      FROM DUAL;

    NLS_CH
    ------
    WE8DEC

See Also: Oracle Database Globalization Support Guide for a list of character set IDs